Re: error message "column "oid" doesn"t exist"
am 05.01.2007 16:05:02 von Erika MarlowThis is a multi-part message in MIME format.
------_=_NextPart_001_01C730DA.E0D9F727
Content-Type: multipart/alternative;
boundary="----_=_NextPart_002_01C730DA.E0D9F727"
------_=_NextPart_002_01C730DA.E0D9F727
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hmm. Well, I am opening the tables for editing. All of the tables have =
unique primary keys that can be referenced. Is there a flag or something =
I can set to prevent it from looking for oid?
=20
Thanks,
Erika
________________________________
From: Oberle, Martin [mailto:martin.oberle@winntec.de]=20
Sent: Wednesday, January 03, 2007 1:36 PM
To: Erika Marlow
Subject: AW: [ODBC] error message "column "oid" doesn't exist"
As far as I know the odbc driver uses the oid to identify the records =
when updating records.
The driver adds the column oid to the query when the driver thinks that =
records mjight be updated
in the future. The error should not occure whe you open the table =
"readonly".
=20
good luck
=20
martin
=20
-----Ursprüngliche Nachricht-----
Von: pgsql-odbc-owner@postgresql.org =
[mailto:pgsql-odbc-owner@postgresql.org]Im Auftrag von Erika Marlow
Gesendet: Dienstag, 2. Januar 2007 19:00
An: pgsql-odbc@postgresql.org
Betreff: Re: [ODBC] error message "column "oid" doesn't exist"
=09
=09
We are recieving the error message "column "oid" doesn't exist" from a =
series of ODBC calls via ADO in a Visual Basic application. The SQL =
statements are all "SELECT * FROM
title=3D"NISC Homepage - www.nisc.coop" = src=3D"cid:974010315@05012007-2C96"=20 border=3D0> | Erika=20 Marlow___________________ size=3D1>Senior=20 Software Specialist National Information Solutions = Cooperative One=20 Innovation Circle Lake St. Louis, MO 63367 color=3D#e70042>+ Email: = color=3D#999999> color=3D"#999999"=20 erika.marlow@nisc.coop color=3D#e70042> face=3Dwingdings>( Phone: color=3D#999999>866.WWW.NISC=20 (866.999.6472) face=3Dwingdings>( Direct: color=3D#999999>636.755.2519=20 = |
------_=_NextPart_002_01C730DA.E0D9F727--
------_=_NextPart_001_01C730DA.E0D9F727
Content-Type: image/gif;
name="nisc.gif"
Content-Transfer-Encoding: base64
Content-ID: <974010315@05012007-2C96>
Content-Description: nisc.gif
Content-Location: nisc.gif
R0lGODlhfgBbAOYAANmvrMU1TDAwLMlFU9zb28zLy769vLS0tJ1rb/DOx6kC OfT09PHx8Z2dne/v
7+ezqcPDwpKSkujBu5ACMLwDQaKioklJRIuLioGBgODg4KuqqoaFfE84N3V0 dGJkWvv7+1MCGHJy
avr6+ubm5nt7e2tra+np6ZOSiWJiYtXV1ayMi9JoZ3cCJlxcW/j4+NDQ0KOi mltcU1RUVOSlmm9R
Ubazrdh6dlNTTd2LgkVDPm1tY52blNjGxMF5guGaj/fp535+dNuDfMMkRqqp pYuKgN6TiMxUW7q5
uNmUlV5GRUADErCvrcaal7ZCXfn089VxbL8JQ14rMdWno+DQzY+PjvLk4vjx 78jIx/Pc2KempBwc
GZeXlc5gZIaGhkQgIqMwTXkcMn5hYSYnI9jU1OPj4/39/WEDHfv4+Ozr6tPS 0tjY2MCWjv///9Fv
ek5OSv7+/mZoYV9gVldYUzs8Nnd3bXcxPff3982hoOrq6MuJiuzs7KURQNfW 0vn5+d+goMAURSH5
BAAAAAAALAAAAAB+AFsAAAf/gGyCg4SFhoeIiYVvjB8fIn0udgsLDJaXDpkO l5aUC3YufY4fjG+K
p6ipqquJpY59VlUJEg8zPkVBQTa7vLtBOEh+DxJTIyZ4epuUdqIfZYys0dLT h4xlH30/CbVFOLm8
T08r4+TjXOfo5yttSABTZMbJDJ/NpdT3+NVv11ZY3DjebIg7Z8TIgIMDAgRI qBDhwYIQIXKxIWVK
BnholLlwZC+fx2jWnPi7FfAJF4MJhaj8AwUKBQouYcZs+eePSiENHyLkkocH gQzGNDqD9rFoqzcf
fkiYUQSXjRUGA6iM+bKq1atYYcpUmROhkZ5qgOJx8EkEKVNG07KxNtIHjqcG /4WwpJq1rl2sUGzi
VKiQy50xP0fomSfqGVq196xVqeUjyJO4f17SvUs5qwIKCi5fhrlX6oA8L1IQ IINm3sZniKnt+8E4
CFSpkyvLxpx5gu3buG1nfnkzQA8eaUbjIXw29SpGThLYwvE4AMvZ0GvbZsHC jBkQ2LODsG6GOgvd
FPT2KBCcNAM7Zokab1XGH9Pmz6FXrk39upL7Srx44ZAkR5IbSQSYBAdRWEfd BLvlxQR5BAh23lDr
IfLGGco1xgVs8lFGn3337ZeDG3LI0QIKI8JRwokhdKCiimHQUMeBmzUBQAEp AEWWKOpFyAhr7w0g
RGwZWqXAdCB0yIEFbsggIv8KKJyoIgkkYCBlF1RWaSUCLyKoABQ9XPHCaIPZ AaGOb7gXxIWRBVnX
kBOYgZ8XFiApw4glpBhlFxdEsMUWDTRQwZ9/9tnAnlvouQUCYCBIQRMG0JiB CTcWlxoj2/hggxE/
qmnZBNUZ6cYNczYZwp1U8FmBBksccMARBrTqqgFHqLqEBhoEWsEJX2QGBRNX BDcCWRvlWNQ+2xTx
hI9ABplZp/nlICedHWCQp58arAoBBFcU8EIaKXTrbQovvFDAFdfGesCsQ6iQ qwJdfkmGHgsEe9hH
xDK1gnOaXlWbm81aACoKcHRAQhdUNJDFEqxmm4YaP100gjEmRPzwCGRkQAD/ AeCOC4EBqh6gwh4K
GOElmAycNi8+xD5QxL1p5vvSkCwUud+zdZJwwRanHmCAlwzDY4I883gidCUM OICGCRVj/AK5rR6B
gAJNaEuyyR7Vu3IAycq3LL8cfDhnwDbjjDAEL/T8c9ChmOVIGWyzPYoIklRi 9AgWZ3ztHXt8QSOY
8UqaWLH3Zh0dpx3GGWoJYVewxM7lnR2vWYadbIgr2EziAB50q5HG0lc08UXZ NvYtLCtlqhy4y7S1
eZ+zILZQQgddRKB4o6KNUNrjZ0meijUfuFCJHhRjnEYBPTQh2qPzpKcaaz48 ga/LyxZuQajRFrz4
FTU6yMxQukvTiAh2FI00/wFqpMBED2E5KK/3TixlwwAtazok13I2GfYQR0Dg a5jpdY8yUuATX9IA
cIeLDAc9qAGJcoLgI9QNSWbO+loIMCC7A5CNZOjx26QAGD49IC0D7xjBWBaA I5BgYQY4GEBMNsPC
l7kQMy5cFgST5DrYbUEDR8BeBg7YvwgRYh+9+50JHua4YJHuB80TAptyw8Qm 4oZ+SbJfwSz4pV+R
UIM+FEQjglg0Pchje6NrBQ4CoIDqcOeMaEwjGoukBK+1IGCxy0IOU2AeqmVR QtfowyQqQQkX9FAV
P2hDDxCAgDC0iAYC4oAiF8nIRjLyBi2gU9gWV4AGRSqMdxzEFiMBCj+OSf8V SFmAHghwhQNUgAoY
6MCJVsnKVroSRVGy3gVNcB4RJDCTiuDdKNaGyWqUwQUMGIEaSlmBLVxASshM pjKhxEwoTalUB2sU
30xWCl3u8prOiJw+rInNXUauFG2rJiixIUoypOAKR9DAoCLAzj0J6p2DKlQE qEAFdh5MA0NA1RKG
kAU6Dqdvb4sbJTjBCU+AgpfVvAbc9kg0gnZiGZ7kXkdU4YAjDGEHJzjBnk6w AQ/grAJZQNWqjpA/
i2L0BECIgwf8lAUD1AAGGSVCCCAZnEeRZQEmUEMBXLoEGPj0p0MYwhJqkD8C IMM0a3MEGgjwAggc
oQZZ+KlPs5BPnZHtUV//LIz/WkGAI2ThBEQIKxE2MFM4hBRhO9OWuLwKViDE YA5mrdYQtgCEEIQA
Dm4QAAmyVaMMXAGqMNjBFmIq1rFuYKx0iEEOthCYMC2ADH+NqmAJG9YNWFas G6BDHNzQgNFASnTS
KAMEloBSOpiWDiHwgBvmsIWD5fBLFzEAaVH7Vi10IWdE0EEMbnCDvGqhAasq wGiHAFMiAEEHcYhB
iJYbA5V64AZzEMBr1QCPF9SAuBg17l2TG6IbhKi5HtCBDuQQ3SMwyIoi2Go1 8PBSIMDBA/CF72bn
gILWHkCHmGsvHOJgATEIQE8VOEANBLyEr6rST6x6KUdDwN/oiuHBDxaA/4Tn MAcxaCEEqTKAuGrQ
0y0YFw5ysEB0BQBhEktYAHPIQQ4EoIUSjO1LtHRBGUCSBtKmNr7xvUEO5tCF GxogDe9Sw2w9QF4t
3EBarY3VXDsqgBIU7KkwyKxuLUBiNzSpTnZVZQv6+1+Dteq6HKXDcyusBS0I wA1vxHKKSoCCG7BY
DLKrFgSo6wAxqbcQIjBAFjaw3xj4Ob4xEDEcugDcKxgVAkPI7XNZjAKBCXas QDhuXqUl1Cjr4L1y
2HEzMYCnC9CTnZ6OAHBdCgMi0AEOin3zDaLF6U7Ts57sjAAJOmAqCwK5zh8g HRpqsAMgENkNn4oD
HPYL3Rx04AIV+DEZ9P/L3wc36dhZsKpFu3DsC/j0BHeFbwzcYIFVjorT9SSU OzXg0l6nVrEWNvaT
7hRqcbu7AXKmowNkTLoaYzvQc3BDcy/tgUALAAUk2MISvLSELYi5yHMYUQgE fq6vwmEOcqCSh48b
3zjI4QYxWHO0pvWnLHh8CLCCAcU3y+IbeDtKeeKTx2nF8pVXS5ojYEAf7kyI PO95vBWWAQo8EAId
eGC+Fjh2shGtaDcbeURUkC0MBksHN4ghBHjawrnB+3OV6oAOGNhAqaiVKlU5 dQgb4HeRc8AkE1XP
YKli1bWu9aprFYC68CLFcXbda9WyuAVyuHq2Mz2HEmBgC1B2b7PF8DX//H01 szGQMJVuRoTeAtu7
MfAAHEJAh0hHegMRSLsBrlXwU8PX6HN6Y7Rkdz1tdUsNqO9WGrjVs8EYEZQv sDF/zYz3DgCBDj7f
9hxkcOwjLGEHYq5twl3H4RPgPg45MLKUblaBBjw8xayTg7Apf9rUEkHtRyi1 z3/udAHIQOd+j4Ac
sRcYiEVsiBMzQUZAu4oP6DnsY48kCiKdbR13GwM10AC2F310FHRBv/zXaGFz MAfQAB2wWhT2IZEH
B+IlXs8VAqzye2EnX3klAN4VMFTQUpXkIEFjBww1NJ7US5NDd75mdPI3aLeX e9wmMD0VdoP3NYpj
cD/XX2JwIgPTAGjl/3sNcAEdgALcdgOS917Dtlk5cAE9hVLbN2b55joYAFyV xENr0zbXcE3adBz2
xmAWoAViwCSN1gUbUFfEdgMhsAFZQFeoNgdaMHwlcF2Kplhp+GzIZkEFIFym ZExSUle4B2hU1gJb
sANfmIR8h2ZQl2wpEHO2tFUTFQ1l8H44pwVkJ0W9lodxEAchcAELxn9ohgL4 J3LvZXRohoEamAKa
cwWylQUNEAE3Q1bvRWQVlgN/Z1pJGAc3YAEiAm0QUIgLcIjVtA/hlIjHwV51 Z3RywCSwg4MYAIbw
dXVgOHgiAgcxeGqb9WBzUgIEQ25fcjEpIFyxgipDYHzvtW0sZmxSsv+KgHZx cDAwFXAEL5AB8NJJ
LiAJmeCBocA93sMHskeDTII4EYBDIud5kidewyZ8IuJiiZZ7yed9fHhRMCCH qScuTPNSuWVxVFZm
MvA6XaBbfuZcPxdeQCBw+vMTSZMGBnACcJACXjQPGURzhbCIewZiaEhfTdKE FgQBKYhj8mV006OJ
AAhdWpCT+cdRh0UEGrUDRLkDPrUFfCYHq2VhPSkHcBQBIfB4GNdcDFh5hzWU grUnQKCUFwMUYSJ3
pDMCWUAEINZfWjCMjXYBLRUaDXBuvPWWPCkGIAIHWxBlRKZjFgYqF+CHl6YD IWB5gHl8OkZmZjY9
rkMCBVMBF6BjzoL/JBgneZQXmKeWV3KQLe4CL30wY6RzBG61Y2+WjwF3Xz9R ALK4YxR2mhbmfU1i
cHxHZgKgcKq1YyoWJ8AWJ6ZJYmUmBrsnf4hzAfCmKkPQBeSFYqfZmHFiAbdZ Zh1gLVVUMpq5Cn1A
BA2GmzngJMimbEO0AZ5JYhBWZmjmd3SQaRL2YFpgZedIAgzGbSMGYRGWYpC0 Iqt0dtdDLqZEBT3o
BtsZYRM2B9MDB6SXQ3RGb6xQBg4gTBBQgF3ATD02cAQAKXrgVwiqSkwSSSZi M9QyBKeYSh3wbaKW
T6a4BVRQJRfgafQ0ol2AAczEaRVENt2yNBbVAKjUTM7kap+mchYk/28Cehx9 wADmBAHqRAWe5mO3
Rgl4QAAFYEoRkKCzJjAE85uwcgBleExRpziyUivrFGux9mojGm6/CQF7Qz5N lU6DcgEnqkwiOqKi
Fm1zFnM5Cko7agJGmk6AsjhfggfxAkzChE7qJE96gnabNy4cY6XUYlUb43u1 Eijw5Cd/cgQAIAWO
6qgAEKmS+qh3cAdMcKlrkKmaugYqMEjsBG/m1aC5qJKa9AHlpFOFunkwVjKO YAcFaqROdS5LoHk8
g3pL41Qk9aehsTlMYy4d86skxQNMIRDhUKzGeqzIGg5QQQETUAcFo6ZApgd2 BhK9wwB6QAbCExo/
QUtiwjYisAAFmv8BmiMuc2h6IEkxdRMuodEzZJA041qu4wKvL8ADD2ApJxER +Jqv+kpGLKAEJCBq
OFRJtJSZpLoWHCQ+FOMz/GMYj9BBQ1QxGRCxCrsJDuBBCTuxmaAHR4OuEdux ErsUzZMSNzGyJFuy
N8GsbkIDsYODGsaOCwCWqVAFuqRHA3UJ9AAhvBM3lqAJDyWPe0RQECUJP1s0 mpAJi2EvDQQ9bhIF
G4eDt0gGzkmqEpAAb9MHVtsHIqA2CPVDQOQIWfu13fQ2WptNbbNLWRsJLjAS Z4I1DtSvXoACo+Kb
A6cGJjCqAyoMCwUK9SCCPlQK7WMLl5Ip0NOvSmBlr+ObB1BJcUf/qoxwBjaA BJPQgVqFS5PTHrWA
AyuALA40AUXCAV9jM+n4AmQwbzCLCo3gBFzQBlXgRUKBRVnECFYAskFgBM8D PZyrBEcCSX7nkXSb
i7e0O9jwAwYhAUQ0GH3zu2RCIZd7LIJruzKDJHKAOBmobKRbsGtROVVwITYA kmeTktYLEkjhHkVw
KbXrvPkBvWkZui5buqBUBgFkAhcyAFLAvZvgvYjRCEfbGJnbvOYLJ1F0bE5o VL77vY3gO8CTBzhh
BABgNvX7R/lgDSKQv67hI/GTLzJ0vv9LaKIZY+x7HI9QCSaQAXdgEwPABQBw MfBgvNQ0Da4gEvXa
GPAhONFRRvdx/yQg0oWFpgZs2sHHgRS+E6480AQUsBBGcAdTEBgjtD25cwrg 9AFnUAUgiwuvER+o
gxmqg7tIMiLFuARr+iDfuwg+XE4Y0wNbshAD0AYVERgZgZIRRbZu47V9IBJR /BaZ6xwyPMMx0y/T
CMAWpMO4xre7cw3AdK0EkAZHkCtD/BDs4A7tqn6bEDRDswBogAW0cAvdIBCQ cceDQ7he4Ea9GWBX
4Md29sW+VK2EnAZX8DGXIQQDIBErEARIIAXDQAwSUMsP8AB+0A0A8Q1QkRKa vMlsFEHDOEEVFMq/
MsppUcBijMoGgADgQcRGoA7jEA690AsDQbsYUsVCwin84r973P9j+LOBXkzK uRTGr8rMNeDM4IET
D1EQ6XCvByEVP/LLWmMb3ew1w9ibLLuqyLxB5OQAIZyNB6oBiHIbu6EXJTsX 2mwZMHPP05PPsLOi
NTIc66Mj19BB2BqmBYYl36Ebu7HQGsImedwswBZJr4MB1tMocHdFgEwvSNEH 4Eo32QgrtXICYQAG
B+LRmwHStCHS/ILBSvJsSDYEtoY8CETOqnHR1joChUyKUDooG0ADOJ3TOr3T M5wZPv3TnZwkS3LS
N6Oml3m8SJ0YB4sGGU2KBXaKxxQGdQAG3eEdTITVci3XuVEf2NEhnQwqXf1t 0KQzb4c8uei6lNsI
MM0AeICtzHz/AHtKprMWBklQINzhHZI92QZiHXdtJBzwKUsiKtGysnLmKFZk R5SLR1xk1hijjWlt
TEqqSnGASFEQBV7ARvgx2/qxH7mrJPJ3ZQIjLaKmOPnz16FNj6Ndznn0O3RT yKhtpah4okvKSnDA
hdA9ItDtbU8CbqaSYTxjU2Uh2MMtIRwErpgjrsOzMedipYVCpmXKTCuy3gKT oovXpzmTPzzjWcDC
EWOdSTkrN0OUrsL1pLOSBc0XT1g64IbSJyAlUmqnLWajwsLd3aqxRb5TNGiA ruSzOcK1MU/aMbO6
4V2nKrl6LV6yMNyrwpDT0g6+O5sUuRX7sBZTPuASLvAa42q1Ui2ieK4/oxEl ft8n7t1TSLNyowd4
gH7t6rFEfhHwYAzIoAzxsrc6vuMojhSvIFANtbM8C7SfkDb23eRO/uDc5LVf m7XYxDa+uOVkXuZm
fuZnHggAOw==
------_=_NextPart_001_01C730DA.E0D9F727--